USE NutritionTracker
GO

DECLARE		@AppUserID	INT
SET		@AppUserID = 1

INSERT INTO		AppUser_AppRole
		(
		AppRoleID,
		AppUserID
		)
SELECT		AppRoleID,
		@AppUserID
FROM		AppRole
WHERE		NOT	EXISTS	(SELECT		1
						FROM	AppUser_AppRole
						WHERE		AppUser_AppRole.AppRoleID = AppRole.AppRoleID
						AND		AppUser_AppRole.AppUserID = @AppUserID)
		